Partially Updating Existing Excel Sheet

Hello

Does there exist any possibility to update the existing Excel sheet partially.
OR
Can i associate an attribute value to particular cell in excel sheet.
The scenario is that:
1. I have an Excel sheet with a large no of parameters and formulae.
2. DOORS module have attributes "value(real)" and "IsInput(boolean)"."value" is used to specify the numerical value of the parameter specified in object and "IsInput" is used to identify the input parameter value.
3. I want to export the "value" attribute from doors module to excel sheet only of input objects in such a way right attribute value is written to right row in excel sheet, So that calculations can be performed in Excel Sheet.
MF2G_qaus_qazah - Thu May 17 02:34:55 EDT 2012

Re: Partially Updating Existing Excel Sheet
SystemAdmin - Fri May 18 04:35:23 EDT 2012

Yes of course it is possible. As an example on how to read (not write) specific cells from Excel see the following thread:

https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14552223

  • Pekka Mäkinen - http://www.softqa.eu/